IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spCratosProject_Update')
	BEGIN
		PRINT 'Dropping Procedure spCratosProject_Update'
		DROP  Procedure  spCratosProject_Update
	END

GO

PRINT 'Creating Procedure spCratosProject_Update'
GO
Create Procedure dbo.spCratosProject_Update
	(
		@CratosProject_ID		bigint,
		@CratosProject_Name	varchar(100)
	)
AS
	/* 
		------------------------------------------------------------------------------
		- Change History
		- --------------
		- Date                 Description
		------------------------------------------------------------------------------
		- 25/06/2010 13:45:27  Initial version Updated
		------------------------------------------------------------------------------
	*/

	-- Declare the required variables

	-- Update the required new record
	UPDATE  [CratosProject]
		SET		[CratosProject].CratosProject_Name	= @CratosProject_Name
	WHERE		[CratosProject].CratosProject_ID		= @CratosProject_ID 

	-- Return to calling method
	RETURN
	
GO
